Overview

Dataset info

Number of variables56
Number of observations122564
Missing cells1462563 (21.3%)
Duplicate rows0 (0.0%)
Total size in memory467.7 MiB
Average record size in memory3.9 KiB

Variables types

CAT53
BOOL2
UNSUPPORTED1

Reproduction info

Date of analysis2020-02-11 18:13:50.657102
Versionpandas-profiling v2.4.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download Configurationconfig.yaml

Warnings

acc_delivery has constant value "CUSA31A369" Rejected
aCode has a high cardinality: 11581 distinct values Warning
AttNames_process has a high cardinality: 1808 distinct values Warning
AttSize_delivery has a high cardinality: 1261 distinct values Warning
AttSize_process has a high cardinality: 1270 distinct values Warning
Cphr_receipt has 3423 (2.8%) missing values Missing
datetime_delivery only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
datetime_delivery has a high cardinality: 8524 distinct values Warning
datetime_process has a high cardinality: 8336 distinct values Warning
datetime_receipt has a high cardinality: 7754 distinct values Warning
Dir_delivery has constant value "Inbound" Rejected
Err_delivery has 122560 (> 99.9%) missing values Missing
Error_receipt has 115083 (93.9%) missing values Missing
Filename_delivery has a high cardinality: 5254 distinct values Warning
Filename_process has a high cardinality: 5242 distinct values Warning
Filename_receipt has a high cardinality: 5188 distinct values Warning
headerFrom_receipt has a high cardinality: 2815 distinct values Warning
Hld_process has 122471 (99.9%) missing values Missing
IP_receipt has a high cardinality: 4083 distinct values Warning
Latency_delivery has a high cardinality: 5439 distinct values Warning
MsgId_delivery has a high cardinality: 10842 distinct values Warning
MsgId_process has a high cardinality: 10793 distinct values Warning
MsgId_receipt has a high cardinality: 10587 distinct values Warning
MsgSize_process has a high cardinality: 8681 distinct values Warning
Rcpt_delivery has a high cardinality: 1303 distinct values Warning
Rcpt_receipt has a high cardinality: 1328 distinct values Warning
ReceiptAck_delivery has a high cardinality: 13679 distinct values Warning
RejCode_delivery has 121917 (99.5%) missing values Missing
RejCode_receipt has 115319 (94.1%) missing values Missing
RejInfo_delivery has 121917 (99.5%) missing values Missing
RejInfo_receipt has 115319 (94.1%) missing values Missing
RejType_delivery has 121917 (99.5%) missing values Missing
RejType_receipt has 115319 (94.1%) missing values Missing
Sender_delivery has a high cardinality: 5711 distinct values Warning
Sender_receipt has a high cardinality: 5695 distinct values Warning
Snt_delivery has a high cardinality: 9860 distinct values Warning
SpamInfo_receipt has 85181 (69.5%) missing values Missing
SpamLimit_receipt has 85181 (69.5%) missing values Missing
SpamScore_receipt has 85181 (69.5%) missing values Missing
Subject_delivery has a high cardinality: 6107 distinct values Warning
Subject_receipt has a high cardinality: 6088 distinct values Warning
TlsVer_receipt has 3423 (2.8%) missing values Missing
Virus_receipt has 122564 (100.0%) missing values Missing
Virus_receipt is an unsupported type, check if it needs cleaning or further analysis Warning
Dir_delivery is highly correlated with acc_deliveryHigh Correlation
acc_delivery is highly correlated with Dir_deliveryHigh Correlation

Variables

acc_delivery
Categorical

CONST
HIGH CORRELATION
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
CUSA31A369
122564
ValueCountFrequency (%) 
CUSA31A369 122564 100.0%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length10
Mean length10
Min length10
Scatter

acc_process
Categorical

Distinct count2
Unique (%)< 0.1%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
CUSA31A369
122494
ValueCountFrequency (%) 
CUSA31A369 122494 99.9%
 
(Missing) 70 0.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length10
Mean length9.996002089
Min length3
Scatter

acc_receipt
Categorical

Distinct count2
Unique (%)< 0.1%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
CUSA31A369
122141
ValueCountFrequency (%) 
CUSA31A369 122141 99.7%
 
(Missing) 423 0.3%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length10
Mean length9.975841193
Min length3
Scatter

aCode
Categorical

HIGH CARDINALITY
Distinct count11581
Unique (%)9.4%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
1cep7I0JObKgYoyRv17sPQ
34100
Rf_arl4wMviUk0MTHWQKeg
22050
7P3N629rOwOJnNRV924Ung
21252
Dcah4IlBOUO-SzEaiMbAXg
 
4732
HJEPO5ZMNqqUw_icmkBAxQ
 
3179
Other values (11576)
37251
ValueCountFrequency (%) 
1cep7I0JObKgYoyRv17sPQ 34100 27.8%
 
Rf_arl4wMviUk0MTHWQKeg 22050 18.0%
 
7P3N629rOwOJnNRV924Ung 21252 17.3%
 
Dcah4IlBOUO-SzEaiMbAXg 4732 3.9%
 
HJEPO5ZMNqqUw_icmkBAxQ 3179 2.6%
 
cuuoEN1IO1yWhdj1oVstdQ 3168 2.6%
 
l-m00IgsOruTg_LDYDyEJw 1176 1.0%
 
icDdrp5zNhS6_Kfk6UzAOg 1176 1.0%
 
zHSFMc7mOA-Ojax9YfklIw 1152 0.9%
 
4GbbmpQaP_GcXvCfctPYuQ 864 0.7%
 
Other values (11571) 29715 24.2%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length36
Mean length22.00068536
Min length22
Scatter

Act_process
Categorical

Distinct count3
Unique (%)< 0.1%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
Acc
122401
Hld
 
93
ValueCountFrequency (%) 
Acc 122401 99.9%
 
Hld 93 0.1%
 
(Missing) 70 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length3
Mean length3
Min length3
Scatter

Act_receipt
Categorical

Distinct count5
Unique (%)< 0.1%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
Acc
114611
Rej
 
7245
Bnc
 
236
Ign
 
49
ValueCountFrequency (%) 
Acc 114611 93.5%
 
Rej 7245 5.9%
 
Bnc 236 0.2%
 
Ign 49 < 0.1%
 
(Missing) 423 0.3%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length3
Mean length3
Min length3
Scatter

AttCnt_delivery
Categorical

Distinct count11
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
1
77340
4
25444
0
17387
2
 
1872
5
 
252
Other values (6)
 
269
ValueCountFrequency (%) 
1 77340 63.1%
 
4 25444 20.8%
 
0 17387 14.2%
 
2 1872 1.5%
 
5 252 0.2%
 
3 235 0.2%
 
6 17 < 0.1%
 
7 10 < 0.1%
 
8 4 < 0.1%
 
10 2 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length2
Mean length1.000016318
Min length1
Scatter

AttCnt_process
Categorical

Distinct count12
Unique (%)< 0.1%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
1
77357
4
25532
0
17199
2
 
1886
5
 
252
Other values (6)
 
268
ValueCountFrequency (%) 
1 77357 63.1%
 
4 25532 20.8%
 
0 17199 14.0%
 
2 1886 1.5%
 
5 252 0.2%
 
3 234 0.2%
 
6 17 < 0.1%
 
7 10 < 0.1%
 
8 4 < 0.1%
 
10 2 < 0.1%
 
(Missing) 70 0.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length3
Mean length1.001158578
Min length1
Scatter

Attempt_delivery
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
1
122540
2
 
20
28
 
4
ValueCountFrequency (%) 
1 122540 > 99.9%
 
2 20 < 0.1%
 
28 4 < 0.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length2
Mean length1.000032636
Min length1
Scatter

AttNames_process
Categorical

HIGH CARDINALITY
Distinct count1808
Unique (%)1.5%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
"image001.jpg", "image002.png", "FasTrack Sales Associate Incentive-Spring 2020.pdf"
60129
"image004.png", "image005.png", "image011.png", "image012.jpg", "Medallion new dealer Q1 (002).pdf", "EnduraMax handout FINAL.pdf", "Cooper Tire Discoverer EduraMax e-Cooper University Training -- Free Polo! (002).pdf", "USAF_Cooper_Feb Promotion.pdf"
22050
13693
"image002.png", "2020_MICHELIN_BFG_FORD_PPDE_FLYER.pdf"
 
5117
"Ford Michelin Mustang Premium Driving Experience.Feb-Mar.pdf", "FORD FEBRUARY 2020 NEWSLETTER.pdf", "Michelin 2020 GM OE Fitment Specials.pdf", "GM FEBRUARY 2020 NEWSLETTER.pdf"
 
3179
Other values (1802)
18326
ValueCountFrequency (%) 
"image001.jpg", "image002.png", "FasTrack Sales Associate Incentive-Spring 2020.pdf" 60129 49.1%
 
"image004.png", "image005.png", "image011.png", "image012.jpg", "Medallion new dealer Q1 (002).pdf", "EnduraMax handout FINAL.pdf", "Cooper Tire Discoverer EduraMax e-Cooper University Training -- Free Polo! (002).pdf", "USAF_Cooper_Feb Promotion.pdf" 22050 18.0%
 
13693 11.2%
 
"image002.png", "2020_MICHELIN_BFG_FORD_PPDE_FLYER.pdf" 5117 4.2%
 
"Ford Michelin Mustang Premium Driving Experience.Feb-Mar.pdf", "FORD FEBRUARY 2020 NEWSLETTER.pdf", "Michelin 2020 GM OE Fitment Specials.pdf", "GM FEBRUARY 2020 NEWSLETTER.pdf" 3179 2.6%
 
"image001.jpg", "OPAT3_Launch_TimingUpdate_Final_020320.pdf" 1176 1.0%
 
"InvoiceC455840.pdf" 1152 0.9%
 
"InvoiceC457170.pdf" 864 0.7%
 
"image001.jpg", "image002.png", "tw redlands 2.4.2020.pdf", "tw sfs 2.4.2020.pdf" 793 0.6%
 
"image001.jpg" 623 0.5%
 
Other values (1797) 13718 11.2%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length347
Mean length100.7905013
Min length0
Scatter

AttSize_delivery
Categorical

HIGH CARDINALITY
Distinct count1261
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
569227
60129
5082731
22050
0
17694
1898092
 
5117
6782785
 
3179
Other values (1256)
14395
ValueCountFrequency (%) 
569227 60129 49.1%
 
5082731 22050 18.0%
 
0 17694 14.4%
 
1898092 5117 4.2%
 
6782785 3179 2.6%
 
303175 1176 1.0%
 
50993 1152 0.9%
 
67633 864 0.7%
 
1350914 793 0.6%
 
121724 560 0.5%
 
Other values (1251) 9850 8.0%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length8
Mean length5.457124441
Min length1
Scatter

AttSize_process
Categorical

HIGH CARDINALITY
Distinct count1270
Unique (%)1.0%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
569227
60129
5082731
22050
0
17506
1898092
 
5117
6782785
 
3179
Other values (1264)
14513
ValueCountFrequency (%) 
569227 60129 49.1%
 
5082731 22050 18.0%
 
0 17506 14.3%
 
1898092 5117 4.2%
 
6782785 3179 2.6%
 
303175 1176 1.0%
 
50993 1152 0.9%
 
67633 864 0.7%
 
1350914 793 0.6%
 
121724 560 0.5%
 
Other values (1259) 9968 8.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length8
Mean length5.46375771
Min length1
Scatter

Cphr_delivery
Categorical

Distinct count3
Unique (%)< 0.1%
Missing24
Missing (%)< 0.1%
Memory size957.6 KiB
TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
79549
TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
42991
ValueCountFrequency (%) 
TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384 79549 64.9%
 
TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 42991 35.1%
 
(Missing) 24 < 0.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length37
Mean length36.99334225
Min length3
Scatter

Cphr_receipt
Categorical

MISSING
Distinct count11
Unique (%)< 0.1%
Missing3423
Missing (%)2.8%
Memory size957.6 KiB
TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
112717
TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
 
2274
TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256
 
1945
TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
 
1872
TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
 
247
Other values (5)
 
86
ValueCountFrequency (%) 
TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 112717 92.0%
 
TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384 2274 1.9%
 
TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256 1945 1.6%
 
TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 1872 1.5%
 
TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA 247 0.2%
 
TLS_DHE_RSA_WITH_AES_256_GCM_SHA384 40 < 0.1%
 
TLS_DHE_RSA_WITH_AES_256_CBC_SHA 33 < 0.1%
 
TLS_DHE_RSA_WITH_AES_128_CBC_SHA 6 < 0.1%
 
TLS_RSA_WITH_AES_256_GCM_SHA384 4 < 0.1%
 
TLS_RSA_WITH_AES_128_CBC_SHA 3 < 0.1%
 
(Missing) 3423 2.8%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length37
Mean length36.0417333
Min length3
Scatter

datetime_delivery
Categorical

TYPE DATE
HIGH CARDINALITY
Distinct count8524
Unique (%)7.0%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
2020-02-03T16:25:08-0500
 
11752
2020-02-03T16:25:10-0500
 
11160
2020-02-03T16:25:09-0500
 
3720
2020-02-03T16:25:13-0500
 
3720
2020-02-03T14:27:10-0500
 
2522
Other values (8519)
89690
ValueCountFrequency (%) 
2020-02-03T16:25:08-0500 11752 9.6%
 
2020-02-03T16:25:10-0500 11160 9.1%
 
2020-02-03T16:25:09-0500 3720 3.0%
 
2020-02-03T16:25:13-0500 3720 3.0%
 
2020-02-03T14:27:10-0500 2522 2.1%
 
2020-02-03T14:27:00-0500 1890 1.5%
 
2020-02-03T14:26:28-0500 1890 1.5%
 
2020-02-03T16:24:50-0500 1860 1.5%
 
2020-02-03T16:25:00-0500 1860 1.5%
 
2020-02-03T16:01:03-0500 1639 1.3%
 
Other values (8514) 80551 65.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length24
Mean length24
Min length24
Scatter

datetime_process
Categorical

HIGH CARDINALITY
Distinct count8336
Unique (%)6.8%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
2020-02-03T16:24:26-0500
 
3412
2020-02-03T16:24:16-0500
 
3410
2020-02-03T16:24:17-0500
 
3410
2020-02-03T16:24:57-0500
 
3410
2020-02-03T16:24:37-0500
 
3410
Other values (8330)
105442
ValueCountFrequency (%) 
2020-02-03T16:24:26-0500 3412 2.8%
 
2020-02-03T16:24:16-0500 3410 2.8%
 
2020-02-03T16:24:17-0500 3410 2.8%
 
2020-02-03T16:24:57-0500 3410 2.8%
 
2020-02-03T16:24:37-0500 3410 2.8%
 
2020-02-03T16:24:27-0500 3410 2.8%
 
2020-02-03T16:25:08-0500 3410 2.8%
 
2020-02-03T16:25:07-0500 3410 2.8%
 
2020-02-03T16:24:38-0500 3410 2.8%
 
2020-02-03T16:24:47-0500 3410 2.8%
 
Other values (8325) 88392 72.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length24
Mean length23.98800627
Min length3
Scatter

datetime_receipt
Categorical

HIGH CARDINALITY
Distinct count7754
Unique (%)6.3%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
2020-02-03T16:24:16-0500
34100
2020-02-03T14:25:15-0500
22050
2020-02-03T16:24:12-0500
21252
2020-02-03T15:59:53-0500
 
4732
2020-02-03T13:58:18-0500
 
3179
Other values (7748)
36828
ValueCountFrequency (%) 
2020-02-03T16:24:16-0500 34100 27.8%
 
2020-02-03T14:25:15-0500 22050 18.0%
 
2020-02-03T16:24:12-0500 21252 17.3%
 
2020-02-03T15:59:53-0500 4732 3.9%
 
2020-02-03T13:58:18-0500 3179 2.6%
 
2020-02-03T16:24:09-0500 3169 2.6%
 
2020-02-03T13:30:05-0500 1177 1.0%
 
2020-02-03T16:39:26-0500 1176 1.0%
 
2020-02-03T15:59:45-0500 1153 0.9%
 
2020-02-03T17:10:08-0500 864 0.7%
 
Other values (7743) 29289 23.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length24
Mean length23.92752358
Min length3
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
true
121913
false
 
651
ValueCountFrequency (%) 
true 121913 99.5%
 
false 651 0.5%
 

Dir_delivery
Categorical

CONST
HIGH CORRELATION
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
Inbound
122564
ValueCountFrequency (%) 
Inbound 122564 100.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length7
Min length7
Scatter

Dir_receipt
Categorical

Distinct count2
Unique (%)< 0.1%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
Inbound
122141
ValueCountFrequency (%) 
Inbound 122141 99.7%
 
(Missing) 423 0.3%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length7
Mean length6.986194968
Min length3
Scatter

Err_delivery
Categorical

MISSING
Distinct count2
Unique (%)< 0.1%
Missing122560
Missing (%)> 99.9%
Memory size957.6 KiB
Domain has no MX records or is invalid
4
ValueCountFrequency (%) 
Domain has no MX records or is invalid 4 < 0.1%
 
(Missing) 122560 > 99.9%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length38
Mean length3.00114226
Min length3
Scatter

Error_receipt
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing115083
Missing (%)93.9%
Memory size957.6 KiB
Failed Known address verification
7245
Rejected by header based manually blocked senders: support@efueling.com - User level block list in force
 
236
ValueCountFrequency (%) 
Failed Known address verification 7245 5.9%
 
Rejected by header based manually blocked senders: support@efueling.com - User level block list in force 236 0.2%
 
(Missing) 115083 93.9%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length104
Mean length4.967837212
Min length3
Scatter

Filename_delivery
Categorical

HIGH CARDINALITY
Distinct count5254
Unique (%)4.3%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
delivery_20200203164052959.log
34117
delivery_20200203145254745.log
22060
delivery_20200203165009325.log
21255
delivery_20200203161722439.log
 
4732
delivery_20200203141108709.log
 
3188
Other values (5249)
37212
ValueCountFrequency (%) 
delivery_20200203164052959.log 34117 27.8%
 
delivery_20200203145254745.log 22060 18.0%
 
delivery_20200203165009325.log 21255 17.3%
 
delivery_20200203161722439.log 4732 3.9%
 
delivery_20200203141108709.log 3188 2.6%
 
delivery_20200203164937842.log 3170 2.6%
 
delivery_20200203135225514.log 1185 1.0%
 
delivery_20200203165257065.log 1176 1.0%
 
delivery_20200203162236137.log 1154 0.9%
 
delivery_20200203171918047.log 864 0.7%
 
Other values (5244) 29663 24.2%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length30
Mean length30
Min length30
Scatter

Filename_process
Categorical

HIGH CARDINALITY
Distinct count5242
Unique (%)4.3%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
process_20200203164053036.log
34116
process_20200203145254722.log
22060
process_20200203165009363.log
21255
process_20200203161722426.log
 
4732
process_20200203141108723.log
 
3188
Other values (5236)
37143
ValueCountFrequency (%) 
process_20200203164053036.log 34116 27.8%
 
process_20200203145254722.log 22060 18.0%
 
process_20200203165009363.log 21255 17.3%
 
process_20200203161722426.log 4732 3.9%
 
process_20200203141108723.log 3188 2.6%
 
process_20200203164937814.log 3170 2.6%
 
process_20200203135225763.log 1185 1.0%
 
process_20200203165257046.log 1176 1.0%
 
process_20200203162236099.log 1154 0.9%
 
process_20200203171918039.log 864 0.7%
 
Other values (5231) 29594 24.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length29
Mean length28.98515062
Min length3
Scatter

Filename_receipt
Categorical

HIGH CARDINALITY
Distinct count5188
Unique (%)4.2%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
receipt_20200203164052967.log
34116
receipt_20200203145254763.log
22060
receipt_20200203165009343.log
21255
receipt_20200203161722289.log
 
4732
receipt_20200203141109159.log
 
3188
Other values (5182)
36790
ValueCountFrequency (%) 
receipt_20200203164052967.log 34116 27.8%
 
receipt_20200203145254763.log 22060 18.0%
 
receipt_20200203165009343.log 21255 17.3%
 
receipt_20200203161722289.log 4732 3.9%
 
receipt_20200203141109159.log 3188 2.6%
 
receipt_20200203164937822.log 3170 2.6%
 
receipt_20200203135225530.log 1185 1.0%
 
receipt_20200203165256974.log 1176 1.0%
 
receipt_20200203162236145.log 1154 0.9%
 
receipt_20200203171917978.log 864 0.7%
 
Other values (5177) 29241 23.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length29
Mean length28.91026729
Min length3
Scatter

headerFrom_receipt
Categorical

HIGH CARDINALITY
Distinct count2815
Unique (%)2.3%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
fastrack@pirelli.com
53424
jscole2@coopertire.com
22051
 
7294
scott.randall@michelin.com
 
5135
jonathan.smart@michelin.com
 
3179
Other values (2809)
31058
ValueCountFrequency (%) 
fastrack@pirelli.com 53424 43.6%
 
jscole2@coopertire.com 22051 18.0%
 
7294 6.0%
 
scott.randall@michelin.com 5135 4.2%
 
jonathan.smart@michelin.com 3179 2.6%
 
km_inventory@kindermorgan.com 2853 2.3%
 
revenue@colpipe.com 2016 1.6%
 
azuredevops@microsoft.com 1581 1.3%
 
messenger@oeconnection.com 1237 1.0%
 
cooperm@toyotires.com 1178 1.0%
 
Other values (2804) 22193 18.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length118
Mean length20.52713684
Min length0
Scatter

Hld_process
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing122471
Missing (%)99.9%
Memory size957.6 KiB
Spm
75
Att
18
ValueCountFrequency (%) 
Spm 75 0.1%
 
Att 18 < 0.1%
 
(Missing) 122471 99.9%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length3
Mean length3
Min length3
Scatter

IP_delivery
Categorical

Distinct count6
Unique (%)< 0.1%
Missing4
Missing (%)< 0.1%
Memory size957.6 KiB
4.28.59.19
79531
104.47.55.110
21098
104.47.70.110
19151
104.47.58.110
 
2742
74.87.121.54
 
38
ValueCountFrequency (%) 
4.28.59.19 79531 64.9%
 
104.47.55.110 21098 17.2%
 
104.47.70.110 19151 15.6%
 
104.47.58.110 2742 2.2%
 
74.87.121.54 38 < 0.1%
 
(Missing) 4 < 0.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length13
Mean length11.05268268
Min length3
Scatter

IP_receipt
Categorical

HIGH CARDINALITY
Distinct count4083
Unique (%)3.3%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
40.107.0.96
34100
67.231.144.140
22071
40.107.0.119
21252
85.158.142.116
 
5117
195.245.230.6
 
3180
Other values (4077)
36421
ValueCountFrequency (%) 
40.107.0.96 34100 27.8%
 
67.231.144.140 22071 18.0%
 
40.107.0.119 21252 17.3%
 
85.158.142.116 5117 4.2%
 
195.245.230.6 3180 2.6%
 
40.107.5.104 3168 2.6%
 
148.163.144.104 2503 2.0%
 
68.232.149.173 1596 1.3%
 
161.47.142.234 1305 1.1%
 
40.107.244.137 1176 1.0%
 
Other values (4072) 26673 21.8%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length15
Mean length12.50917888
Min length3
Scatter

Latency_delivery
Categorical

HIGH CARDINALITY
Distinct count5439
Unique (%)4.4%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
67871
 
1518
67534
 
1518
68071
 
1012
57421
 
1012
47334
 
1012
Other values (5434)
116492
ValueCountFrequency (%) 
67871 1518 1.2%
 
67534 1518 1.2%
 
68071 1012 0.8%
 
57421 1012 0.8%
 
47334 1012 0.8%
 
111231 630 0.5%
 
131970 630 0.5%
 
69384 630 0.5%
 
152952 630 0.5%
 
152018 630 0.5%
 
Other values (5429) 113342 92.5%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length9
Mean length4.956014817
Min length2
Scatter

MsgId_delivery
Categorical

HIGH CARDINALITY
Distinct count10842
Unique (%)8.8%
Missing6
Missing (%)< 0.1%
Memory size957.6 KiB
<204e29910cd545b0a077ae14e82b0854@EXC023-201IT.group.pirelli.com>
59697
<DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com>
22050
<VE1PR09MB30073226928949312943A2779D000@VE1PR09MB3007.eurprd09.prod.outlook.com>
 
5117
<DB7PR09MB24429781CCE7AD2A7C61F890FA000@DB7PR09MB2442.eurprd09.prod.outlook.com>
 
3179
<BN8PR14MB2548B56772022EDCD850CCB2A8000@BN8PR14MB2548.namprd14.prod.outlook.com>
 
1176
Other values (10836)
31339
ValueCountFrequency (%) 
<204e29910cd545b0a077ae14e82b0854@EXC023-201IT.group.pirelli.com> 59697 48.7%
 
<DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> 22050 18.0%
 
<VE1PR09MB30073226928949312943A2779D000@VE1PR09MB3007.eurprd09.prod.outlook.com> 5117 4.2%
 
<DB7PR09MB24429781CCE7AD2A7C61F890FA000@DB7PR09MB2442.eurprd09.prod.outlook.com> 3179 2.6%
 
<BN8PR14MB2548B56772022EDCD850CCB2A8000@BN8PR14MB2548.namprd14.prod.outlook.com> 1176 1.0%
 
<219b9d47-d08a-406b-9a1e-f0ab23cdccad@SP-EX05.info.colpipe.com> 1152 0.9%
 
<a8902599-6144-4c99-82d3-b80d95763ad5@SP-EX05.info.colpipe.com> 864 0.7%
 
<BYAPR03MB3846D695C0B2748451FD3426A7030@BYAPR03MB3846.namprd03.prod.outlook.com> 793 0.6%
 
<cd33c732-4c27-45d8-82bf-f083001448c9@HOUEXEDGE1.kindermorgan.com> 560 0.5%
 
<cf8afd6c-cd69-4727-99b1-f810a80fff0a@SP-EX05.info.colpipe.com> 486 0.4%
 
Other values (10831) 27484 22.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length187
Mean length69.83124735
Min length3
Scatter

MsgId_process
Categorical

HIGH CARDINALITY
Distinct count10793
Unique (%)8.8%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
<204e29910cd545b0a077ae14e82b0854@EXC023-201IT.group.pirelli.com>
59697
<DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com>
22050
<VE1PR09MB30073226928949312943A2779D000@VE1PR09MB3007.eurprd09.prod.outlook.com>
 
5117
<DB7PR09MB24429781CCE7AD2A7C61F890FA000@DB7PR09MB2442.eurprd09.prod.outlook.com>
 
3179
<BN8PR14MB2548B56772022EDCD850CCB2A8000@BN8PR14MB2548.namprd14.prod.outlook.com>
 
1176
Other values (10787)
31275
ValueCountFrequency (%) 
<204e29910cd545b0a077ae14e82b0854@EXC023-201IT.group.pirelli.com> 59697 48.7%
 
<DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> 22050 18.0%
 
<VE1PR09MB30073226928949312943A2779D000@VE1PR09MB3007.eurprd09.prod.outlook.com> 5117 4.2%
 
<DB7PR09MB24429781CCE7AD2A7C61F890FA000@DB7PR09MB2442.eurprd09.prod.outlook.com> 3179 2.6%
 
<BN8PR14MB2548B56772022EDCD850CCB2A8000@BN8PR14MB2548.namprd14.prod.outlook.com> 1176 1.0%
 
<219b9d47-d08a-406b-9a1e-f0ab23cdccad@SP-EX05.info.colpipe.com> 1152 0.9%
 
<a8902599-6144-4c99-82d3-b80d95763ad5@SP-EX05.info.colpipe.com> 864 0.7%
 
<BYAPR03MB3846D695C0B2748451FD3426A7030@BYAPR03MB3846.namprd03.prod.outlook.com> 793 0.6%
 
<cd33c732-4c27-45d8-82bf-f083001448c9@HOUEXEDGE1.kindermorgan.com> 560 0.5%
 
<DM6PR05MB43956598E8AFD3C2D59E1D93C2030@DM6PR05MB4395.namprd05.prod.outlook.com> 486 0.4%
 
Other values (10782) 27420 22.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length187
Mean length69.67112692
Min length3
Scatter

MsgId_receipt
Categorical

HIGH CARDINALITY
Distinct count10587
Unique (%)8.6%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
<204e29910cd545b0a077ae14e82b0854@EXC023-201IT.group.pirelli.com>
59697
<DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com>
22050
<VE1PR09MB30073226928949312943A2779D000@VE1PR09MB3007.eurprd09.prod.outlook.com>
 
5117
<DB7PR09MB24429781CCE7AD2A7C61F890FA000@DB7PR09MB2442.eurprd09.prod.outlook.com>
 
3179
<BN8PR14MB2548B56772022EDCD850CCB2A8000@BN8PR14MB2548.namprd14.prod.outlook.com>
 
1176
Other values (10581)
30922
ValueCountFrequency (%) 
<204e29910cd545b0a077ae14e82b0854@EXC023-201IT.group.pirelli.com> 59697 48.7%
 
<DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> 22050 18.0%
 
<VE1PR09MB30073226928949312943A2779D000@VE1PR09MB3007.eurprd09.prod.outlook.com> 5117 4.2%
 
<DB7PR09MB24429781CCE7AD2A7C61F890FA000@DB7PR09MB2442.eurprd09.prod.outlook.com> 3179 2.6%
 
<BN8PR14MB2548B56772022EDCD850CCB2A8000@BN8PR14MB2548.namprd14.prod.outlook.com> 1176 1.0%
 
<219b9d47-d08a-406b-9a1e-f0ab23cdccad@SP-EX05.info.colpipe.com> 1152 0.9%
 
<a8902599-6144-4c99-82d3-b80d95763ad5@SP-EX05.info.colpipe.com> 864 0.7%
 
<BYAPR03MB3846D695C0B2748451FD3426A7030@BYAPR03MB3846.namprd03.prod.outlook.com> 793 0.6%
 
<cd33c732-4c27-45d8-82bf-f083001448c9@HOUEXEDGE1.kindermorgan.com> 560 0.5%
 
<cf8afd6c-cd69-4727-99b1-f810a80fff0a@SP-EX05.info.colpipe.com> 486 0.4%
 
Other values (10576) 27067 22.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length187
Mean length69.66798571
Min length3
Scatter

MsgSize_process
Categorical

HIGH CARDINALITY
Distinct count8681
Unique (%)7.1%
Missing70
Missing (%)0.1%
Memory size957.6 KiB
600263
34100
5397594
22050
600265
21252
1940671
 
5116
6799303
 
3179
Other values (8675)
36797
ValueCountFrequency (%) 
600263 34100 27.8%
 
5397594 22050 18.0%
 
600265 21252 17.3%
 
1940671 5116 4.2%
 
6799303 3179 2.6%
 
600259 3168 2.6%
 
600279 1177 1.0%
 
330053 1176 1.0%
 
54984 1152 0.9%
 
71627 864 0.7%
 
Other values (8670) 29260 23.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length8
Mean length6.003826572
Min length3
Scatter

Rcpt_delivery
Categorical

HIGH CARDINALITY
Distinct count1303
Unique (%)1.1%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
dburton@usautoforce.com
 
1150
jtelken@usautoforce.com
 
1147
bmorang@usautoforce.com
 
1145
dchapin@usautoforce.com
 
1145
hsossaman@usautoforce.com
 
1142
Other values (1298)
116835
ValueCountFrequency (%) 
dburton@usautoforce.com 1150 0.9%
 
jtelken@usautoforce.com 1147 0.9%
 
bmorang@usautoforce.com 1145 0.9%
 
dchapin@usautoforce.com 1145 0.9%
 
hsossaman@usautoforce.com 1142 0.9%
 
jjarvis@usautoforce.com 1142 0.9%
 
sgoodro@usautoforce.com 1142 0.9%
 
jcarlson@usautoforce.com 1141 0.9%
 
jaudi@usautoforce.com 1141 0.9%
 
jjarrett@usautoforce.com 1140 0.9%
 
Other values (1293) 111129 90.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length63
Mean length25.86177018
Min length13
Scatter

Rcpt_receipt
Categorical

HIGH CARDINALITY
Distinct count1328
Unique (%)1.1%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
dburton@usautoforce.com
 
1106
jtelken@usautoforce.com
 
1103
dchapin@usautoforce.com
 
1101
bmorang@usautoforce.com
 
1101
jjarvis@usautoforce.com
 
1098
Other values (1322)
116632
ValueCountFrequency (%) 
dburton@usautoforce.com 1106 0.9%
 
jtelken@usautoforce.com 1103 0.9%
 
dchapin@usautoforce.com 1101 0.9%
 
bmorang@usautoforce.com 1101 0.9%
 
jjarvis@usautoforce.com 1098 0.9%
 
hsossaman@usautoforce.com 1098 0.9%
 
sgoodro@usautoforce.com 1098 0.9%
 
jaudi@usautoforce.com 1097 0.9%
 
jcarlson@usautoforce.com 1097 0.9%
 
jjarrett@usautoforce.com 1096 0.9%
 
Other values (1317) 111146 90.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length63
Mean length25.75242322
Min length3
Scatter

ReceiptAck_delivery
Categorical

HIGH CARDINALITY
Distinct count13679
Unique (%)11.2%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
null
 
651
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=232117212548409, Hostname=COPWS002.usoil.local] Queued mail for delivery
 
630
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=234500919397586, Hostname=COPWS001.usoil.local] Queued mail for delivery
 
630
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=232117212548368, Hostname=COPWS002.usoil.local] Queued mail for delivery
 
630
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=234500919397632, Hostname=COPWS001.usoil.local] Queued mail for delivery
 
630
Other values (13674)
119393
ValueCountFrequency (%) 
null 651 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=232117212548409, Hostname=COPWS002.usoil.local] Queued mail for delivery 630 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=234500919397586, Hostname=COPWS001.usoil.local] Queued mail for delivery 630 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=232117212548368, Hostname=COPWS002.usoil.local] Queued mail for delivery 630 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=234500919397632, Hostname=COPWS001.usoil.local] Queued mail for delivery 630 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=234500919397660, Hostname=COPWS001.usoil.local] Queued mail for delivery 630 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=232117212548395, Hostname=COPWS002.usoil.local] Queued mail for delivery 630 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=232117212548429, Hostname=COPWS002.usoil.local] Queued mail for delivery 630 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=234500919397592, Hostname=COPWS001.usoil.local] Queued mail for delivery 630 0.5%
 
250 2.6.0 <DM6PR11MB4329A0B1EE86E3E425230D8395000@DM6PR11MB4329.namprd11.prod.outlook.com> [InternalId=232117212548257, Hostname=COPWS002.usoil.local] Queued mail for delivery 630 0.5%
 
Other values (13669) 116243 94.8%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length282
Mean length183.5348063
Min length4
Scatter

RejCode_delivery
Categorical

MISSING
Distinct count4
Unique (%)< 0.1%
Missing121917
Missing (%)99.5%
Memory size957.6 KiB
550
626
421
 
20
554
 
1
ValueCountFrequency (%) 
550 626 0.5%
 
421 20 < 0.1%
 
554 1 < 0.1%
 
(Missing) 121917 99.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length3
Mean length3
Min length3
Scatter

RejCode_receipt
Categorical

MISSING
Distinct count2
Unique (%)< 0.1%
Missing115319
Missing (%)94.1%
Memory size957.6 KiB
550
7245
ValueCountFrequency (%) 
550 7245 5.9%
 
(Missing) 115319 94.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length3
Mean length3
Min length3
Scatter

RejInfo_delivery
Categorical

MISSING
Distinct count10
Unique (%)< 0.1%
Missing121917
Missing (%)99.5%
Memory size957.6 KiB
5.4.1 Recipient address rejected: Access denied. AS(201806281) [BN7NAM10FT047.eop-nam10.prod.protection.outlook.com]
620
4.3.2 The maximum number of concurrent connections has exceeded a limit, closing transmission channel
 
20
5.4.1 Recipient address rejected: Access denied. AS(201806281) [MW2NAM10FT046.eop-nam10.prod.protection.outlook.com]
 
1
5.4.14 Hop count exceeded - possible mail loop ATTR34 [BN7NAM10FT056.eop-nam10.prod.protection.outlook.com]
 
1
5.4.1 Recipient address rejected: Access denied. AS(201806281) [BN7NAM10FT006.eop-nam10.prod.protection.outlook.com]
 
1
Other values (4)
 
4
ValueCountFrequency (%) 
5.4.1 Recipient address rejected: Access denied. AS(201806281) [BN7NAM10FT047.eop-nam10.prod.protection.outlook.com] 620 0.5%
 
4.3.2 The maximum number of concurrent connections has exceeded a limit, closing transmission channel 20 < 0.1%
 
5.4.1 Recipient address rejected: Access denied. AS(201806281) [MW2NAM10FT046.eop-nam10.prod.protection.outlook.com] 1 < 0.1%
 
5.4.14 Hop count exceeded - possible mail loop ATTR34 [BN7NAM10FT056.eop-nam10.prod.protection.outlook.com] 1 < 0.1%
 
5.4.1 Recipient address rejected: Access denied. AS(201806281) [BN7NAM10FT006.eop-nam10.prod.protection.outlook.com] 1 < 0.1%
 
5.4.1 Recipient address rejected: Access denied. AS(201806281) [MW2NAM10FT008.eop-nam10.prod.protection.outlook.com] 1 < 0.1%
 
5.4.1 Recipient address rejected: Access denied. AS(201806281) [BN7NAM10FT017.eop-nam10.prod.protection.outlook.com] 1 < 0.1%
 
5.4.1 Recipient address rejected: Access denied. AS(201806281) [DM6NAM10FT033.eop-nam10.prod.protection.outlook.com] 1 < 0.1%
 
5.4.1 Recipient address rejected: Access denied. AS(201806281) [BN7NAM10FT008.eop-nam10.prod.protection.outlook.com] 1 < 0.1%
 
(Missing) 121917 99.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length116
Mean length3.59399171
Min length3
Scatter

RejInfo_receipt
Categorical

MISSING
Distinct count2
Unique (%)< 0.1%
Missing115319
Missing (%)94.1%
Memory size957.6 KiB
Invalid Recipient
7245
ValueCountFrequency (%) 
Invalid Recipient 7245 5.9%
 
(Missing) 115319 94.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length17
Mean length3.827567638
Min length3
Scatter

RejType_delivery
Categorical

MISSING
Distinct count4
Unique (%)< 0.1%
Missing121917
Missing (%)99.5%
Memory size957.6 KiB
Recipient email address is possibly incorrect
626
Recipient server unavailable or busy
 
20
Recipient email server rejected the message
 
1
ValueCountFrequency (%) 
Recipient email address is possibly incorrect 626 0.5%
 
Recipient server unavailable or busy 20 < 0.1%
 
Recipient email server rejected the message 1 < 0.1%
 
(Missing) 121917 99.5%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length45
Mean length3.220227799
Min length3
Scatter

RejType_receipt
Categorical

MISSING
Distinct count2
Unique (%)< 0.1%
Missing115319
Missing (%)94.1%
Memory size957.6 KiB
Invalid Recipient Address
7245
ValueCountFrequency (%) 
Invalid Recipient Address 7245 5.9%
 
(Missing) 115319 94.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length25
Mean length4.300463431
Min length3
Scatter

Route_delivery
Categorical

Distinct count4
Unique (%)< 0.1%
Missing24
Missing (%)< 0.1%
Memory size957.6 KiB
Definition for 4.28.59.19
79531
Office 365 Primary
42991
Definition for 74.87.121.54
 
18
ValueCountFrequency (%) 
Definition for 4.28.59.19 79531 64.9%
 
Office 365 Primary 42991 35.1%
 
Definition for 74.87.121.54 18 < 0.1%
 
(Missing) 24 < 0.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length27
Mean length22.54063999
Min length3
Scatter

Sender_delivery
Categorical

HIGH CARDINALITY
Distinct count5711
Unique (%)4.7%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
fastrack@pirelli.com
59698
jscole2@coopertire.com
22051
scott.randall@michelin.com
 
5135
km_inventory@kindermorgan.com
 
3546
jonathan.smart@michelin.com
 
3179
Other values (5706)
28955
ValueCountFrequency (%) 
fastrack@pirelli.com 59698 48.7%
 
jscole2@coopertire.com 22051 18.0%
 
scott.randall@michelin.com 5135 4.2%
 
km_inventory@kindermorgan.com 3546 2.9%
 
jonathan.smart@michelin.com 3179 2.6%
 
revenue@colpipe.com 2016 1.6%
 
azuredevops@microsoft.com 1581 1.3%
 
messenger@oeconnection.com 1305 1.1%
 
cooperm@toyotires.com 1178 1.0%
 
ocaballero@srnatire.com 812 0.7%
 
Other values (5701) 22063 18.0%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length134
Mean length24.01059854
Min length2
Scatter

Sender_receipt
Categorical

HIGH CARDINALITY
Distinct count5695
Unique (%)4.6%
Missing423
Missing (%)0.3%
Memory size957.6 KiB
fastrack@pirelli.com
59698
jscole2@coopertire.com
22051
scott.randall@michelin.com
 
5135
km_inventory@kindermorgan.com
 
3546
jonathan.smart@michelin.com
 
3179
Other values (5689)
28532
ValueCountFrequency (%) 
fastrack@pirelli.com 59698 48.7%
 
jscole2@coopertire.com 22051 18.0%
 
scott.randall@michelin.com 5135 4.2%
 
km_inventory@kindermorgan.com 3546 2.9%
 
jonathan.smart@michelin.com 3179 2.6%
 
revenue@colpipe.com 2016 1.6%
 
azuredevops@microsoft.com 1581 1.3%
 
messenger@oeconnection.com 1305 1.1%
 
cooperm@toyotires.com 1178 1.0%
 
ocaballero@srnatire.com 812 0.7%
 
Other values (5684) 21640 17.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length134
Mean length24.0070657
Min length2
Scatter

Snt_delivery
Categorical

HIGH CARDINALITY
Distinct count9860
Unique (%)8.0%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
7371724
 
6930
819180
 
6820
819179
 
6200
819174
 
6072
7371725
 
5670
Other values (9855)
90872
ValueCountFrequency (%) 
7371724 6930 5.7%
 
819180 6820 5.6%
 
819179 6200 5.1%
 
819174 6072 5.0%
 
7371725 5670 4.6%
 
819178 5466 4.5%
 
819182 4960 4.0%
 
819177 4732 3.9%
 
819175 4554 3.7%
 
819173 4224 3.4%
 
Other values (9850) 66936 54.6%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length8
Mean length6.006168206
Min length1
Scatter

SpamInfo_receipt
Categorical

MISSING
Distinct count2
Unique (%)< 0.1%
Missing85181
Missing (%)69.5%
Memory size957.6 KiB
[]
37383
ValueCountFrequency (%) 
[] 37383 30.5%
 
(Missing) 85181 69.5%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length2.694992004
Min length2
Scatter

SpamLimit_receipt
Categorical

MISSING
Distinct count4
Unique (%)< 0.1%
Missing85181
Missing (%)69.5%
Memory size957.6 KiB
5
35941
0
 
1441
28
 
1
ValueCountFrequency (%) 
5 35941 29.3%
 
0 1441 1.2%
 
28 1 < 0.1%
 
(Missing) 85181 69.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length3
Mean length2.389992167
Min length1
Scatter

SpamScore_receipt
Categorical

MISSING
Distinct count16
Unique (%)< 0.1%
Missing85181
Missing (%)69.5%
Memory size957.6 KiB
2
23091
0
11410
1
 
1508
4
 
846
3
 
372
Other values (10)
 
156
ValueCountFrequency (%) 
2 23091 18.8%
 
0 11410 9.3%
 
1 1508 1.2%
 
4 846 0.7%
 
3 372 0.3%
 
10 122 0.1%
 
5 16 < 0.1%
 
-27 6 < 0.1%
 
-28 3 < 0.1%
 
8 3 < 0.1%
 
Other values (5) 6 < 0.1%
 
(Missing) 85181 69.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length2.391175223
Min length1
Scatter

Subject_delivery
Categorical

HIGH CARDINALITY
Distinct count6107
Unique (%)5.0%
Missing413
Missing (%)0.3%
Memory size957.6 KiB
Pirelli Spring 2020 Sales Team Incentive (Spiffs)
59697
Q1 Cooper Medallion Promotions
22050
FW: Mustang Madness Incentive February_March 2.3.2020
 
5117
MICHELIN FEBRUARY CAR DEALER CHANNEL INFORMATION FOR GM/FORD
 
3179
Colonial Invoice for USO
 
2016
Other values (6101)
30092
ValueCountFrequency (%) 
Pirelli Spring 2020 Sales Team Incentive (Spiffs) 59697 48.7%
 
Q1 Cooper Medallion Promotions 22050 18.0%
 
FW: Mustang Madness Incentive February_March 2.3.2020 5117 4.2%
 
MICHELIN FEBRUARY CAR DEALER CHANNEL INFORMATION FOR GM/FORD 3179 2.6%
 
Colonial Invoice for USO 2016 1.6%
 
TOYO Open Country A/T III Launch 1176 1.0%
 
RE: Falken Loads -2/4/2020 793 0.6%
 
CUSTOMER REPORT - END OF MONTH from N. AUGUSTA #2 terminal 560 0.5%
 
Load 6 Sarnia 486 0.4%
 
Shippers storage by origin: USO 486 0.4%
 
Other values (6096) 26591 21.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length152
Mean length45.55358833
Min length0
Scatter

Subject_receipt
Categorical

HIGH CARDINALITY
Distinct count6088
Unique (%)5.0%
Missing433
Missing (%)0.4%
Memory size957.6 KiB
Pirelli Spring 2020 Sales Team Incentive (Spiffs)
59697
Q1 Cooper Medallion Promotions
22050
FW: Mustang Madness Incentive February_March 2.3.2020
 
5117
MICHELIN FEBRUARY CAR DEALER CHANNEL INFORMATION FOR GM/FORD
 
3179
Colonial Invoice for USO
 
2016
Other values (6082)
30072
ValueCountFrequency (%) 
Pirelli Spring 2020 Sales Team Incentive (Spiffs) 59697 48.7%
 
Q1 Cooper Medallion Promotions 22050 18.0%
 
FW: Mustang Madness Incentive February_March 2.3.2020 5117 4.2%
 
MICHELIN FEBRUARY CAR DEALER CHANNEL INFORMATION FOR GM/FORD 3179 2.6%
 
Colonial Invoice for USO 2016 1.6%
 
TOYO Open Country A/T III Launch 1176 1.0%
 
RE: Falken Loads -2/4/2020 793 0.6%
 
CUSTOMER REPORT - END OF MONTH from N. AUGUSTA #2 terminal 560 0.5%
 
Load 6 Sarnia 486 0.4%
 
Shippers storage by origin: USO 486 0.4%
 
Other values (6077) 26571 21.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length152
Mean length45.54688163
Min length0
Scatter

TlsVer_delivery
Categorical

Distinct count2
Unique (%)< 0.1%
Missing24
Missing (%)< 0.1%
Memory size957.6 KiB
TLSv1.2
122540
ValueCountFrequency (%) 
TLSv1.2 122540 > 99.9%
 
(Missing) 24 < 0.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length7
Mean length6.999216736
Min length3
Scatter

TlsVer_receipt
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing3423
Missing (%)2.8%
Memory size957.6 KiB
TLSv1.2
119085
TLSv1
 
56
ValueCountFrequency (%) 
TLSv1.2 119085 97.2%
 
TLSv1 56 < 0.1%
 
(Missing) 3423 2.8%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length7
Mean length6.887373128
Min length3
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size957.6 KiB
Yes
122540
No
 
24
ValueCountFrequency (%) 
Yes 122540 > 99.9%
 
No 24 < 0.1%
 

Virus_receipt
Unsupported

MISSING
UNSUPPORTED
Missing122564
Missing (%)100.0%
Memory size957.6 KiB

Correlations

Missing values

Sample

First rows

acc_deliveryacc_processacc_receiptaCodeAct_processAct_receiptAttCnt_deliveryAttCnt_processAttempt_deliveryAttNames_processAttSize_deliveryAttSize_processCphr_deliveryCphr_receiptdatetime_deliverydatetime_processdatetime_receiptDelivered_deliveryDir_deliveryDir_receiptErr_deliveryError_receiptFilename_deliveryFilename_processFilename_receiptheaderFrom_receiptHld_processIP_deliveryIP_receiptLatency_deliveryMsgId_deliveryMsgId_processMsgId_receiptMsgSize_processRcpt_deliveryRcpt_receiptReceiptAck_deliveryRejCode_deliveryRejCode_receiptRejInfo_deliveryRejInfo_receiptRejType_deliveryRejType_receiptRoute_deliverySender_deliverySender_receiptSnt_deliverySpamInfo_receiptSpamLimit_receiptSpamScore_receiptSubject_deliverySubject_receiptTlsVer_deliveryTlsVer_receiptUseTls_deliveryVirus_receipt
0CUSA31A369CUSA31A369CUSA31A369--CwPmFPNbuDTH-5kwkOcAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA2562020-02-03T14:06:37-05002020-02-03T14:06:36-05002020-02-03T14:06:35-0500trueInboundInboundNaNNaNdelivery_20200203143118147.logprocess_20200203143118108.logreceipt_20200203143118049.logstore-news@amazon.comNaN4.28.59.1954.240.15.1233072<010001700c727969-c6663a40-147e-4e93-ac1d-9d7d...<010001700c727969-c6663a40-147e-4e93-ac1d-9d7d...<010001700c727969-c6663a40-147e-4e93-ac1d-9d7d...65040lsmarzinski@usoil.comlsmarzinski@usoil.com250 2.6.0 <010001700c727969-c6663a40-147e-4e93...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.192020020319063313e9785472d4411bb3d36768c090p0na...2020020319063313e9785472d4411bb3d36768c090p0na...71270[]50Larry Smarzinski, explore Laptop Accessories f...Larry Smarzinski, explore Laptop Accessories f...TLSv1.2TLSv1.2YesNaN
1CUSA31A369CUSA31A369CUSA31A369--JY2D0POJyXcLK-oZQtswAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA3842020-02-03T20:42:06-05002020-02-03T20:42:04-05002020-02-03T20:42:04-0500trueInboundInboundNaNNaNdelivery_20200203205247315.logprocess_20200203205247282.logreceipt_20200203205247299.logappletv@insideapple.apple.comNaN4.28.59.1917.179.250.2204147<2000164102.301921463.1580780521655@Insideappl...<2000164102.301921463.1580780521655@Insideappl...<2000164102.301921463.1580780521655@Insideappl...94773stlouisreturns@usventure.comstlouisreturns@usventure.com250 2.6.0 <2000164102.301921463.1580780521655@...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19appletv_i_bounces@insideapple.apple.comappletv_i_bounces@insideapple.apple.com102338[]50What to Watch: Explore the work of visionary b...What to Watch: Explore the work of visionary b...TLSv1.2TLSv1.2YesNaN
2CUSA31A369CUSA31A369CUSA31A369--LRL-MaPkGfg_6P5WVpMAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384NaN2020-02-03T18:43:44-05002020-02-03T18:43:44-05002020-02-03T18:43:43-0500trueInboundInboundNaNNaNdelivery_20200203185246554.logprocess_20200203185246528.logreceipt_20200203185246537.logpetromail@dtnenergy.comNaN4.28.59.1969.41.210.31963<DTN;PETRO2;85B17E3B;D0121B9958BC49D391F326D00...<DTN;PETRO2;85B17E3B;D0121B9958BC49D391F326D00...<DTN;PETRO2;85B17E3B;D0121B9958BC49D391F326D00...20381dsalvatore@usoil.comdsalvatore@usoil.com250 2.6.0 <DTN;PETRO2;85B17E3B;D0121B9958BC49D...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19petromail@dtnenergy.competromail@dtnenergy.com22621NaNNaNNaNMESSAGE FROM TEX9 0062 PRF-4176 02-03-2020 17:...MESSAGE FROM TEX9 0062 PRF-4176 02-03-2020 17:...TLSv1.2NaNYesNaN
3CUSA31A369CUSA31A369CUSA31A369--yhq7U9PlWf4WE6fbDT6AAccAcc111"INV~1001841~41962232~~1910537338~0445167.pdf"6406664066TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384NaN2020-02-03T17:05:36-05002020-02-03T17:05:35-05002020-02-03T17:05:35-0500trueInboundInboundNaNNaNdelivery_20200203173256515.logprocess_20200203173256477.logreceipt_20200203173256495.logsales@kumhotireusa.comNaN4.28.59.1938.101.232.1632644<EC6E18430B67B183C0B303438070A009E273F541@OMS....<EC6E18430B67B183C0B303438070A009E273F541@OMS....<EC6E18430B67B183C0B303438070A009E273F541@OMS....68237sandraschko@usautoforce.comsandraschko@usautoforce.com250 2.6.0 <EC6E18430B67B183C0B303438070A009E27...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19btv1==302cf868bf1==aa7h-marketingsales@kumhoti...btv1==302cf868bf1==aa7h-marketingsales@kumhoti...93404[]50Invoice 1910537338Invoice 1910537338TLSv1.2NaNYesNaN
4CUSA31A369CUSA31A369CUSA31A369-0FCCVlZMfCZDmnUlgy2XwAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA3842020-02-03T13:44:13-05002020-02-03T13:44:12-05002020-02-03T13:44:12-0500trueInboundInboundNaNNaNdelivery_20200203141252170.logprocess_20200203141252221.logreceipt_20200203141252496.logjheckman@usautoforce.comNaN4.28.59.1913.108.254.1331869<_nSLS0000000000000000000000000000000000000000...<_nSLS0000000000000000000000000000000000000000...<_nSLS0000000000000000000000000000000000000000...2336jheckman@usautoforce.comjheckman@usautoforce.com250 2.6.0 <_nSLS000000000000000000000000000000...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19jheckman=usautoforce.com__3p2l6fsly1v07ilu@y1p...jheckman=usautoforce.com__3p2l6fsly1v07ilu@y1p...4038[]50Product Discount Change Request Approved by ABMProduct Discount Change Request Approved by ABMTLSv1.2TLSv1.2YesNaN
5CUSA31A369CUSA31A369CUSA31A369-0KkLSIRPS-4o8L3E9r02gAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA2562020-02-03T16:46:24-05002020-02-03T16:46:23-05002020-02-03T16:46:23-0500trueInboundInboundNaNNaNdelivery_20200203171303782.logprocess_20200203171304322.logreceipt_20200203171304492.lognoreply@transport4.comNaN4.28.59.1954.240.9.372687<010001700d04c64a-0fc33b4c-e67d-4feb-a10d-281c...<010001700d04c64a-0fc33b4c-e67d-4feb-a10d-281c...<010001700d04c64a-0fc33b4c-e67d-4feb-a10d-281c...67896jlambert@usoil.comjlambert@usoil.com250 2.6.0 <010001700d04c64a-0fc33b4c-e67d-4feb...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19010001700d04c64a-0fc33b4c-e67d-4feb-a10d-281c2...010001700d04c64a-0fc33b4c-e67d-4feb-a10d-281c2...93976[]52T4 Schedule: Explorer - 10 sent to j_guthery (...T4 Schedule: Explorer - 10 sent to j_guthery (...TLSv1.2TLSv1.2YesNaN
6CUSA31A369CUSA31A369CUSA31A369-0Xfh7D8Od2YZhewG6AEeQAccAcc111"2020020313003687__USOIL425_INVMGR_1__USOIL425...625625TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA3842020-02-03T14:17:30-05002020-02-03T14:17:29-05002020-02-03T14:17:28-0500trueInboundInboundNaNNaNdelivery_20200203142642098.logprocess_20200203142642119.logreceipt_20200203142642900.logalerts@ipayables.comNaN4.28.59.19104.47.70.1053049<BN7PR08MB4739B01A178B5306C9814F9DD0000@BN7PR0...<BN7PR08MB4739B01A178B5306C9814F9DD0000@BN7PR0...<BN7PR08MB4739B01A178B5306C9814F9DD0000@BN7PR0...7594jlefebvre@usgain.comjlefebvre@usgain.com250 2.6.0 <BN7PR08MB4739B01A178B5306C9814F9DD0...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19alerts@ipayables.comalerts@ipayables.com9369NaNNaNNaNBatch Interface Submission Results - 202002031...Batch Interface Submission Results - 202002031...TLSv1.2TLSv1.2YesNaN
7CUSA31A369CUSA31A369CUSA31A369-0_ciK9COHede0kx-GJQLQAccAcc001"image001.png", "image002.png", "image003.png"00TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA2562020-02-03T15:05:48-05002020-02-03T15:05:43-05002020-02-03T15:05:43-0500trueInboundInboundNaNNaNdelivery_20200203150950347.logprocess_20200203150950331.logreceipt_20200203150950276.logcustomerservice@shopcwo.comNaN4.28.59.19209.85.161.442969<0bb901d5dacd$4e258410$ea708c30$@shopcwo.com><0bb901d5dacd$4e258410$ea708c30$@shopcwo.com><0bb901d5dacd$4e258410$ea708c30$@shopcwo.com>80317dl-etailer@usventure.comdl-etailer@usventure.com250 2.6.0 <0bb901d5dacd$4e258410$ea708c30$@sho...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19customerservice@shopcwo.comcustomerservice@shopcwo.com108321NaNNaNNaN1148100 !!!!!!!! CANCEL !!!!!!!!!!!!!!!!!!!!...1148100 !!!!!!!! CANCEL !!!!!!!!!!!!!!!!!!!!...TLSv1.2TLSv1.2YesNaN
8CUSA31A369CUSA31A369CUSA31A369-0saCzYvNsaIcklOrFc0EAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384NaN2020-02-03T15:42:41-05002020-02-03T15:42:40-05002020-02-03T15:42:40-0500trueInboundInboundNaNNaNdelivery_20200203160918681.logprocess_20200203160918784.logreceipt_20200203160918624.logyourtank@centeron.netNaN4.28.59.1965.204.98.52847<RIPDPROSVC01qc7IZZH0000ac9e@RIPDPROSVC01.RIPD...<RIPDPROSVC01qc7IZZH0000ac9e@RIPDPROSVC01.RIPD...<RIPDPROSVC01qc7IZZH0000ac9e@RIPDPROSVC01.RIPD...1277srenfrow@uslube.comdkreczmer@uslube.com250 2.6.0 <RIPDPROSVC01qc7IZZH0000ac9e@RIPDPRO...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19yourtank@mail2.centeron.netyourtank@mail2.centeron.net2788[]51Setpoint AlertSetpoint AlertTLSv1.2NaNYesNaN
9CUSA31A369CUSA31A369CUSA31A369-0saCzYvNsaIcklOrFc0EAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384NaN2020-02-03T15:42:41-05002020-02-03T15:42:40-05002020-02-03T15:42:40-0500trueInboundInboundNaNNaNdelivery_20200203160918681.logprocess_20200203160918784.logreceipt_20200203160918624.logyourtank@centeron.netNaN4.28.59.1965.204.98.52847<RIPDPROSVC01qc7IZZH0000ac9e@RIPDPROSVC01.RIPD...<RIPDPROSVC01qc7IZZH0000ac9e@RIPDPROSVC01.RIPD...<RIPDPROSVC01qc7IZZH0000ac9e@RIPDPROSVC01.RIPD...1277srenfrow@uslube.combmaskell@uslube.com250 2.6.0 <RIPDPROSVC01qc7IZZH0000ac9e@RIPDPRO...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19yourtank@mail2.centeron.netyourtank@mail2.centeron.net2788[]51Setpoint AlertSetpoint AlertTLSv1.2NaNYesNaN

Last rows

acc_deliveryacc_processacc_receiptaCodeAct_processAct_receiptAttCnt_deliveryAttCnt_processAttempt_deliveryAttNames_processAttSize_deliveryAttSize_processCphr_deliveryCphr_receiptdatetime_deliverydatetime_processdatetime_receiptDelivered_deliveryDir_deliveryDir_receiptErr_deliveryError_receiptFilename_deliveryFilename_processFilename_receiptheaderFrom_receiptHld_processIP_deliveryIP_receiptLatency_deliveryMsgId_deliveryMsgId_processMsgId_receiptMsgSize_processRcpt_deliveryRcpt_receiptReceiptAck_deliveryRejCode_deliveryRejCode_receiptRejInfo_deliveryRejInfo_receiptRejType_deliveryRejType_receiptRoute_deliverySender_deliverySender_receiptSnt_deliverySpamInfo_receiptSpamLimit_receiptSpamScore_receiptSubject_deliverySubject_receiptTlsVer_deliveryTlsVer_receiptUseTls_deliveryVirus_receipt
122554CUSA31A369CUSA31A369CUSA31A369zyZM7yzcOGyNtQzXYi1xbAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA2562020-02-03T17:27:33-05002020-02-03T17:27:32-05002020-02-03T17:27:31-0500trueInboundInboundNaNNaNdelivery_20200203174419224.logprocess_20200203174419403.logreceipt_20200203174419055.logbpconnection@bp.comNaN4.28.59.1994.100.245.1233517<ADR450000001807451001402EC80B6841EEA91DA8B20C...<ADR450000001807451001402EC80B6841EEA91DA8B20C...<ADR450000001807451001402EC80B6841EEA91DA8B20C...23243sbevers@usoil.comcwolter@usoil.com250 2.6.0 <ADR450000001807451001402EC80B6841EE...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19bpconnection@bp.combpconnection@bp.com26158NaNNaNNaNEoR - Branded Jobber - US VENTURE INC - 02/03/...EoR - Branded Jobber - US VENTURE INC - 02/03/...TLSv1.2TLSv1.2YesNaN
122555CUSA31A369CUSA31A369CUSA31A369zyZM7yzcOGyNtQzXYi1xbAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA2562020-02-03T17:27:33-05002020-02-03T17:27:32-05002020-02-03T17:27:31-0500trueInboundInboundNaNNaNdelivery_20200203174419224.logprocess_20200203174419403.logreceipt_20200203174419055.logbpconnection@bp.comNaN4.28.59.1994.100.245.1233517<ADR450000001807451001402EC80B6841EEA91DA8B20C...<ADR450000001807451001402EC80B6841EEA91DA8B20C...<ADR450000001807451001402EC80B6841EEA91DA8B20C...23243sbevers@usoil.comdsalvatore@usoil.com250 2.6.0 <ADR450000001807451001402EC80B6841EE...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19bpconnection@bp.combpconnection@bp.com26158NaNNaNNaNEoR - Branded Jobber - US VENTURE INC - 02/03/...EoR - Branded Jobber - US VENTURE INC - 02/03/...TLSv1.2TLSv1.2YesNaN
122556CUSA31A369CUSA31A369CUSA31A369zyZM7yzcOGyNtQzXYi1xbAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA2562020-02-03T17:27:33-05002020-02-03T17:27:32-05002020-02-03T17:27:31-0500trueInboundInboundNaNNaNdelivery_20200203174419224.logprocess_20200203174419403.logreceipt_20200203174419055.logbpconnection@bp.comNaN4.28.59.1994.100.245.1233517<ADR450000001807451001402EC80B6841EEA91DA8B20C...<ADR450000001807451001402EC80B6841EEA91DA8B20C...<ADR450000001807451001402EC80B6841EEA91DA8B20C...23243sbevers@usoil.comsbevers@usoil.com250 2.6.0 <ADR450000001807451001402EC80B6841EE...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19bpconnection@bp.combpconnection@bp.com26158NaNNaNNaNEoR - Branded Jobber - US VENTURE INC - 02/03/...EoR - Branded Jobber - US VENTURE INC - 02/03/...TLSv1.2TLSv1.2YesNaN
122557CUSA31A369CUSA31A369CUSA31A369zyZM7yzcOGyNtQzXYi1xbAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA2562020-02-03T17:27:33-05002020-02-03T17:27:32-05002020-02-03T17:27:31-0500trueInboundInboundNaNNaNdelivery_20200203174419224.logprocess_20200203174419403.logreceipt_20200203174419055.logbpconnection@bp.comNaN4.28.59.1994.100.245.1233517<ADR450000001807451001402EC80B6841EEA91DA8B20C...<ADR450000001807451001402EC80B6841EEA91DA8B20C...<ADR450000001807451001402EC80B6841EEA91DA8B20C...23243sbevers@usoil.comszeinert@usoil.com250 2.6.0 <ADR450000001807451001402EC80B6841EE...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19bpconnection@bp.combpconnection@bp.com26158NaNNaNNaNEoR - Branded Jobber - US VENTURE INC - 02/03/...EoR - Branded Jobber - US VENTURE INC - 02/03/...TLSv1.2TLSv1.2YesNaN
122558CUSA31A369CUSA31A369CUSA31A369zzHWCVdnNg6npsfprGoeRAAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA3842020-02-03T13:40:13-05002020-02-03T13:40:10-05002020-02-03T13:40:10-0500trueInboundInboundNaNNaNdelivery_20200203141302018.logprocess_20200203141302088.logreceipt_20200203141301927.logmbakas@ameresco.comNaN4.28.59.1940.107.94.1125839<DM5PR07MB281296A845A08F394E259549A3000@DM5PR0...<DM5PR07MB281296A845A08F394E259549A3000@DM5PR0...<DM5PR07MB281296A845A08F394E259549A3000@DM5PR0...9569mkoel@usgain.commkoel@usgain.com250 2.6.0 <DM5PR07MB281296A845A08F394E259549A3...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19mbakas@ameresco.commbakas@ameresco.com11208NaNNaNNaNRe: Sold $1.50 -2019 rinsRe: Sold $1.50 -2019 rinsTLSv1.2TLSv1.2YesNaN
122559CUSA31A369CUSA31A369CUSA31A369zzQnywCWOTmhYDw5F8ad1AAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA3842020-02-03T13:24:29-05002020-02-03T13:24:29-05002020-02-03T13:24:28-0500trueInboundInboundNaNNaNdelivery_20200203133959337.logprocess_20200203133959299.logreceipt_20200203133959319.logazuredevops@microsoft.comNaN4.28.59.19207.46.200.142222<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...25478dkoepke@usautoforce.comdkoepke@usautoforce.com250 2.6.0 <db739375193840189b8d6ef2ada0c888-JV...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19azuredevops@microsoft.comazuredevops@microsoft.com35721[]00Product Backlog Item 24179 - Ship Back Rejecte...Product Backlog Item 24179 - Ship Back Rejecte...TLSv1.2TLSv1.2YesNaN
122560CUSA31A369CUSA31A369CUSA31A369zzQnywCWOTmhYDw5F8ad1AAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA3842020-02-03T13:24:29-05002020-02-03T13:24:29-05002020-02-03T13:24:28-0500trueInboundInboundNaNNaNdelivery_20200203133959337.logprocess_20200203133959299.logreceipt_20200203133959319.logazuredevops@microsoft.comNaN4.28.59.19207.46.200.142222<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...25478dkoepke@usautoforce.commkrueger@usventure.com250 2.6.0 <db739375193840189b8d6ef2ada0c888-JV...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19azuredevops@microsoft.comazuredevops@microsoft.com35721[]00Product Backlog Item 24179 - Ship Back Rejecte...Product Backlog Item 24179 - Ship Back Rejecte...TLSv1.2TLSv1.2YesNaN
122561CUSA31A369CUSA31A369CUSA31A369zzQnywCWOTmhYDw5F8ad1AAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA3842020-02-03T13:24:29-05002020-02-03T13:24:29-05002020-02-03T13:24:28-0500trueInboundInboundNaNNaNdelivery_20200203133959337.logprocess_20200203133959299.logreceipt_20200203133959319.logazuredevops@microsoft.comNaN4.28.59.19207.46.200.142222<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...25478mkrueger@usventure.comdkoepke@usautoforce.com250 2.6.0 <db739375193840189b8d6ef2ada0c888-JV...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19azuredevops@microsoft.comazuredevops@microsoft.com35720[]00Product Backlog Item 24179 - Ship Back Rejecte...Product Backlog Item 24179 - Ship Back Rejecte...TLSv1.2TLSv1.2YesNaN
122562CUSA31A369CUSA31A369CUSA31A369zzQnywCWOTmhYDw5F8ad1AAccAcc00100TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA3842020-02-03T13:24:29-05002020-02-03T13:24:29-05002020-02-03T13:24:28-0500trueInboundInboundNaNNaNdelivery_20200203133959337.logprocess_20200203133959299.logreceipt_20200203133959319.logazuredevops@microsoft.comNaN4.28.59.19207.46.200.142222<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...<db739375193840189b8d6ef2ada0c888-JVKUGUBNKBZG...25478mkrueger@usventure.commkrueger@usventure.com250 2.6.0 <db739375193840189b8d6ef2ada0c888-JV...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19azuredevops@microsoft.comazuredevops@microsoft.com35720[]00Product Backlog Item 24179 - Ship Back Rejecte...Product Backlog Item 24179 - Ship Back Rejecte...TLSv1.2TLSv1.2YesNaN
122563CUSA31A369CUSA31A369CUSA31A369zzjdDgAvOOiRYOMSzAdKHwAccAcc111"uso_coa_BillDetail_0203201640017047472.pdf"249453249453TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA2562020-02-03T17:40:06-05002020-02-03T17:40:04-05002020-02-03T17:40:04-0500trueInboundInboundNaNNaNdelivery_20200203175339675.logprocess_20200203175339642.logreceipt_20200203175339686.lognoreply@transport4.comNaN4.28.59.1954.240.9.373853<010001700d35e8c0-9ec3664a-2d66-4eff-a1eb-047a...<010001700d35e8c0-9ec3664a-2d66-4eff-a1eb-047a...<010001700d35e8c0-9ec3664a-2d66-4eff-a1eb-047a...252153plinvoices@usoil.complinvoices@usoil.com250 2.6.0 <010001700d35e8c0-9ec3664a-2d66-4eff...NaNNaNNaNNaNNaNNaNDefinition for 4.28.59.19010001700d35e8c0-9ec3664a-2d66-4eff-a1eb-047aa...010001700d35e8c0-9ec3664a-2d66-4eff-a1eb-047aa...345856[]50T4 Carrier Invoice sent to uso_coa (Auto Push)T4 Carrier Invoice sent to uso_coa (Auto Push)TLSv1.2TLSv1.2YesNaN